-
Re: PMO Template Project Plan not displaying correct End Date at top row
Hi @Kathy PPT - bizarre it's not auto-calculating. Presume if you click on the cell you've circled you get the below warning message, which will confirm it is set up correctly. The one thing for me i…1 · -
Re: Formula using the RYG status balls
How about this: =IF([Deployment complete]@row = 1, "Green", IF([Module Go-Live Date]@row <> "", "Yellow", "Blue")) This assumes you won't have a case whe…1 · -
Re: Same Column - Row Type Header = Sum value of Row Type Detail
Glad you liked it! This part of the formula ensures it only counts items that are listed as 'Detail' ie excludes header, and then only counts values above zero in the debit column and below zero in t…1 · -
Re: Same Column - Row Type Header = Sum value of Row Type Detail
If you want to keep the column formulas (I always try to), then how about this... Debit column: =IF([Row Type]@row = "Header", SUMIFS(AMT:AMT, [JE Report]:[JE Report], [JE Report]@row, [Row…1 ·
